Tomcat5.5 환경에서 Ibatis 와 dbcp를 연동하기 위해서

Tomcat5.5_HOME/common/lib 디렉토리에 ibatis-2.3.0.677b.jar (ibatis) 모듈, classes12.jar 모듈을 카피한다.

다음의 설정파일을 생성한다.

[sqlmap-config.xml]

위치 : WEB-INF/classes/sqlmap-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
  <properties resource="properties/database.properties"/>
  <transactionManager type="JDBC">
    <dataSource type="DBCP">
      <property name="driverClassName"   value="${driver}"  />
      <property name="url"      value="${url}"   />
      <property name="username"     value="${username}" />
      <property name="password"     value="${password}" />
      <property name="maxActive"     value="10"/>
      <property name="initialSize"     value="1"/>
      <property name="removeAbandoned"    value="true"/>
      <property name="removeAbandonedTimeout"  value="60"/>
      <property name="logAbandoned"    value="true"/>
    </dataSource>

  </transactionManager>
  <sqlMap resource="sql/member.xml" ></sqlMap>
</sqlMapConfig>

[database.properties]

위치 : WEB-INF/classes/properties/database.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/test?autoReconnect=true